﻿using MVC1.Models;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace MVC1.Controllers
{
    public class SelectController : Controller
    {
        //
        // GET: /Select/
        //string sql = " SELECT * FROM test.[dbo].[代码_病人记帐对照表]";
        public ActionResult Index()
        {
            return View();
        }
        List<PropModels> list = new List<PropModels>();
        public ActionResult Select()
        {
            PropModels read=new PropModels();
            /*
            SqlDataReader reader=SqlHelper.ExecuteReader(sql);
            if (reader.Read())
            {
                read.记帐代码 = reader.GetString(0);
                read.记帐类型 = reader.GetString(1);
                read.分组名称 = reader.GetString(2);
                read.病人标识 = reader.GetString(3);
                read.门诊结算方式 = reader.GetString(4);
                read.住院结算方式 = reader.GetString(5);
                read.可换记帐代码 = reader.GetString(6);
                read.门诊住院标志 = reader.GetInt32(7);
                read.参保类型 = reader.GetInt32(8);
                read.显示性质 = reader.GetInt32(9);
                read.零票打印 = reader.GetInt32(10);
                read.结算顺序 = reader.GetInt32(11);
                read.备注 = reader.GetString(12);

                list.Add(read);
                ViewData["DataList"] = list;
            }*/
            
            return View();
        }
    }
}
